How to: Calculate Redist. Preview

The complete Store Stock Redistribution process is done in the following steps:

The Redist. Preview calculation is based on a calculated Replenishment Item Quantity table. In a first step, the Redist. Demand and Redist. Stock is calculated for every item, variant, and location. This calculation uses the selected Redist. Calculation Type to determine Redist. Demand and Redist. Stock. Next, the result is saved in the Redistribution Stock Quantity (RSQ) table on item, variant, and location level. The Redist. Preview holds this information on item level, the Redist. Preview Line on item and variant level. Only locations that are set up in the Redist. Matrix are considered in the RSQ calculation.

To calculate the Redist. Preview

  1. Go to LS Retail - Replenishment - Automatic - Tasks - Redistribution Replenishment Journal.
  2. Open the Redistribution Journal.
  3. Click the Add Items to Journal/Preview action. This opens the Add Items to Redist. Journal report. The filters and some setup fields from the Replenishment Template will be shown in this report.
  4. Change filters or field values, if needed.
  5. Click OK to create the report.

For calculation types other than Manual Redistribution, if the field Create Journal Lines in the Replenishment Template is set to Create Redist. Preview Only, the report will only calculate the Preview and will not create Journal Lines. This lets the user review the result before the Replen. Journal Lines are created. For more information see How to: Set Up Redistribution Templates .

To open and review the Redist. Preview

  1. When the Redist. Preview has been calculated successfully, click the Show Redist. Preview action in the Process group. This opens the Redistribution Journal Preview page.
    Note: This page looks different for different Redist. Calculation Types.

  2. To see detailed information on item and variant level, click the Show Variants action.
  3. To see detailed information on item, variant, and location level, click the Show Details action.
    On this level you can see the detailed stock information and if the location is considered as a location with Redist. Stock or Redist. Demand. The Exclude field lets you exclude specific locations from the later trips calculation.

To manually adjust the Redist. Stock and Redist. Demand Quantities

  1. When the Redist. Preview has been calculated successfully, click the Show Redist. Preview action in the Process group. This opens the Redistribution Journal Preview page.

  2. Select the relevant item and click Show Items Availability action under the Home menu. This opens the Retail Item Variant Availability by Location page. Alternatively, you can perform a lookup on the Stockout % or Variant Availability fields.

    For Redist. Calculation TypeManual Redistribution, View byInventory (Transfer Quantity) is the only editable mode. For all other calculation types, the only editable mode is Eff. Inventory (Transfer Quantity).

  3. Key in the desired quantity in the corresponding value cells, per item, variant, and location. The system auto-translates the input value into transfer quantity. The valid inputs are a whole number or a number with a plus (+) or minus (-) sign. For detailed instructions on how to manually create the transfer quantities, refer to Retail Item Variant Availability by Location.

To exclude items or locations in the Redist. Preview

  1. When the Redist. Preview has been calculated successfully, click the Show Redist. Preview action in the Process group. This opens the Redistribution Journal Preview page.
    Note: This page looks different for different Redist. Calculation Types.

  2. To exclude items manually from the later Trips calculation, select the Exclude field.
  3. To exclude multiple items from the later Trips calculation, click the Set Exclude (Item) action. When you click this action, all (filtered) items in the current page will be set to Excluded.
  4. To undo the exclude for multiple items, click the Remove Exclude (Item) action. When you click this action, all (filtered) items in the current page will be set to Included.
  5. The actions Set Exclude (Location) and Remove Exclude (Location) open a page where you can select the locations. Depending on the selected action, the locations will be set to excluded or included.

    6. Note: The actions Set Exclude (Location), Remove Exclude (Location) and Remove Exclude (All) are not available for Redist. Calculation Type Manual Redistribution.

See Also

Store Stock Redistribution

Store Stock Redistribution Process